19. Exercise: Filter Data

Exercise: Filter Data

In the following exercise, you'll once again start with the American League Baseball salaries data set to practice on. There are a few different filtering challenges, each progressively harder. Complete them all successfully to score a run on the baseball field!

Pro Tip: When working calculations over a filtered subset of the data, copy the filtered table to a new tabbed sheet first so that the hidden data isn't part of the calculation.

Task Description:

The following list has a series of steps for this exercise. As you complete each step, check it off the list. The quizzes in the task list can be found below.

Task List:

Task Feedback:

Score!

First Base

QUESTION:

How many players with the last name Anderson are in the league?

SOLUTION:

NOTE: The solutions are expressed in RegEx pattern. Udacity uses these patterns to check the given answer

Second Base

QUESTION:

How many different teams pay at least one Second Baseman a salary of exactly $300,000 ?

SOLUTION:

NOTE: The solutions are expressed in RegEx pattern. Udacity uses these patterns to check the given answer

Third Base

QUESTION:

How many infielders, whose first name begins with "J" are on the Seattle Mariners team? An infielder is defined as a player in the First Baseman, Second Baseman, Third Baseman, or Shortstop position.

SOLUTION:

NOTE: The solutions are expressed in RegEx pattern. Udacity uses these patterns to check the given answer

Home Plate

QUESTION:

What is the average salary for a pitcher on a California team? Round your answer to the nearest dollar. (Only Oakland and Anaheim are California teams)

SOLUTION:

NOTE: The solutions are expressed in RegEx pattern. Udacity uses these patterns to check the given answer

Next Concept